Original Column Name |
Expanded Column Name |
Description |
GLSBATID |
General Ledger Sub-Batch ID |
Unique identifier for a sub-batch within the general ledger. |
Amt |
Amount |
Total financial value handled in the sub-batch. |
Balance |
Balance |
Current outstanding balance after transactions in the sub-batch. |
CAID |
Cash Account ID |
Identifier for the cash account involved in the sub-batch. |
CAGrpID |
Cash Account Group ID |
Identifier for the group of cash accounts the transaction belongs to. |
DeptID |
Department ID |
Identifier for the department responsible for the sub-batch. |
DescX |
Description |
Detailed narrative explaining the purpose or contents of the sub-batch. |
DtClr |
Date Cleared |
Date when the sub-batch was finalized and cleared. |
DtPost |
Date Posted |
Date when the sub-batch was officially posted to the general ledger. |
DtTrans |
Date Transaction |
Date when the actual transactions within the sub-batch occurred. |
EmpID |
Employee ID |
Identifier for the employee related to the transactions in the sub-batch. |
GLID |
General Ledger ID |
Identifier for a specific entry within the general ledger. |
GLSBATID_Ref |
General Ledger Sub-Batch ID Reference |
Referential ID linking the sub-batch to other related records or entries. |
IsCleared |
Is Cleared |
Indicator specifying whether the sub-batch has been cleared (true/false). |
IsPrint |
Is Printed |
Indicator showing if the sub-batch records have been physically printed (true/false). |
IsVoided |
Is Voided |
Indicator of whether the sub-batch has been voided or invalidated (true/false). |
ItemPOID |
Item Purchase Order ID |
Identifier of the purchase order related to the transaction items. |
PayMethodID |
Payment Method ID |
Identifier for the payment method used in the transactions. |
RecptID |
Recipient ID |
Identifier for the recipient of funds or transactions. |
RecptTypeID |
Recipient Type ID |
Identifier for the type or category of the transaction recipient. |
RefNo |
Reference Number |
Unique reference number for identifying the sub-batch. |
RefText |
Reference Text |
Additional text providing context or details related to the reference number. |
SiteID |
Site ID |
Identifier for the physical or logical site related to the transaction. |
TransTypeID |
Transaction Type ID |
Identifier defining the type of transaction within the sub-batch. |
ZUChkSum |
ZU Check Sum |
Checksum value used for data integrity verification in audit logs. |
ZUDate |
ZU Date |
Date and time when an entry was used or modified for audit purposes. |
ZULogonHisID |
ZU Logon History ID |
Identifier for a specific user logon event for auditing. |